Imports¶

In [2]:
pip install plotly 
Collecting plotly
  Downloading plotly-5.16.1-py2.py3-none-any.whl (15.6 MB)
Requirement already satisfied: packaging in c:\users\92321\anaconda3\lib\site-packages (from plotly) (21.0)
Collecting tenacity>=6.2.0
  Downloading tenacity-8.2.3-py3-none-any.whl (24 kB)
Requirement already satisfied: pyparsing>=2.0.2 in c:\users\92321\anaconda3\lib\site-packages (from packaging->plotly) (3.0.4)
Installing collected packages: tenacity, plotly
Successfully installed plotly-5.16.1 tenacity-8.2.3
Note: you may need to restart the kernel to use updated packages.
In [3]:
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline
import seaborn as sns
import plotly.express as px
from IPython.core.display import display, HTML
display(HTML("<style>.container {width:100% !important; }</style>"))

Read CSV¶

In [4]:
playstore = pd.read_csv("Google-Playstore.csv", encoding="utf-8")

Exploratory Analysis¶

In [5]:
playstore.head(10)
Out[5]:
App Name App Id Category Rating Rating Count Installs Minimum Installs Maximum Installs Free Price ... Developer Website Developer Email Released Last Updated Content Rating Privacy Policy Ad Supported In App Purchases Editors Choice Scraped Time
0 Gakondo com.ishakwe.gakondo Adventure 0.0 0.0 10+ 10.0 15 True 0.0 ... https://beniyizibyose.tk/#/ jean21101999@gmail.com Feb 26, 2020 Feb 26, 2020 Everyone https://beniyizibyose.tk/projects/ False False False 2021-06-15 20:19:35
1 Ampere Battery Info com.webserveis.batteryinfo Tools 4.4 64.0 5,000+ 5000.0 7662 True 0.0 ... https://webserveis.netlify.app/ webserveis@gmail.com May 21, 2020 May 06, 2021 Everyone https://dev4phones.wordpress.com/licencia-de-uso/ True False False 2021-06-15 20:19:35
2 Vibook com.doantiepvien.crm Productivity 0.0 0.0 50+ 50.0 58 True 0.0 ... NaN vnacrewit@gmail.com Aug 9, 2019 Aug 19, 2019 Everyone https://www.vietnamairlines.com/vn/en/terms-an... False False False 2021-06-15 20:19:35
3 Smart City Trichy Public Service Vehicles 17UC... cst.stJoseph.ug17ucs548 Communication 5.0 5.0 10+ 10.0 19 True 0.0 ... http://www.climatesmarttech.com/ climatesmarttech2@gmail.com Sep 10, 2018 Oct 13, 2018 Everyone NaN True False False 2021-06-15 20:19:35
4 GROW.me com.horodyski.grower Tools 0.0 0.0 100+ 100.0 478 True 0.0 ... http://www.horodyski.com.pl rmilekhorodyski@gmail.com Feb 21, 2020 Nov 12, 2018 Everyone http://www.horodyski.com.pl False False False 2021-06-15 20:19:35
5 IMOCCI com.imocci Social 0.0 0.0 50+ 50.0 89 True 0.0 ... http://www.imocci.com info@imocci.com Dec 24, 2018 Dec 20, 2019 Teen https://www.imocci.com/wp-content/uploads/2018... False True False 2021-06-15 20:19:35
6 unlimited 4G data prank free app getfreedata.superfatiza.unlimitedjiodataprank Libraries & Demo 4.5 12.0 1,000+ 1000.0 2567 True 0.0 ... NaN aitomgharfatimezzahra@gmail.com Sep 23, 2019 Sep 27, 2019 Everyone https://sites.google.com/view/unlimited4gdatap... True False False 2021-06-15 20:19:35
7 The Everyday Calendar com.mozaix.simoneboard Lifestyle 2.0 39.0 500+ 500.0 702 True 0.0 ... NaN elementuser03@gmail.com Jun 21, 2019 Jun 21, 2019 Everyone https://www.freeprivacypolicy.com/privacy/view... False False False 2021-06-15 20:19:35
8 WhatsOpen com.whatsopen.app Communication 0.0 0.0 10+ 10.0 18 True 0.0 ... http://yilvermolinah.com yilver.mh1996@gmail.com NaN Dec 07, 2018 Teen http://elcafedelamanana.yilvermolinah.com/poli... False False False 2021-06-15 20:19:35
9 Neon 3d Iron Tech Keyboard Theme com.ikeyboard.theme.neon_3d.iron.tech Personalization 4.7 820.0 50,000+ 50000.0 62433 True 0.0 ... https://trendyteme888-31139.web.app trendyteme.888@gmail.com Sep 22, 2019 Oct 07, 2020 Everyone http://bit.ly/EmojiThemePro True False False 2021-06-15 20:19:35

10 rows × 24 columns

In [7]:
playstore.tail()
Out[7]:
App Name App Id Category Rating Rating Count Installs Minimum Installs Maximum Installs Free Price ... Developer Website Developer Email Released Last Updated Content Rating Privacy Policy Ad Supported In App Purchases Editors Choice Scraped Time
2312939 大俠客—熱血歸來 com.rxsj.ssjj Role Playing 4.3 16775.0 100,000+ 100000.0 337109 True 0.0 ... http://www.4399sy.com.hk/ ssjjcomhk@gmail.com NaN Jun 01, 2021 Teen http://a.4399sy.com.hk/user/aggreement False False False 2021-06-16 12:59:18
2312940 ORU Online com.threedream.oruonline Education 0.0 0.0 100+ 100.0 430 True 0.0 ... http://www.oru.edu/ 3DreamDeveloper@gmail.com Jan 17, 2018 Feb 02, 2018 Everyone http://www.oru.edu/about-oru/privacy-policy.php False False False 2021-06-16 12:59:19
2312941 Data Structure datastructure.appoworld.datastucture Education 0.0 0.0 100+ 100.0 202 True 0.0 ... NaN appoworld.official@gmail.com Aug 19, 2018 Aug 19, 2018 Everyone https://appoworld.000webhostapp.com/datastruct... False False False 2021-06-16 12:59:19
2312942 Devi Suktam ishan.devi.suktam Music & Audio 3.5 8.0 1,000+ 1000.0 2635 True 0.0 ... https://a70f78905.app-ads-txt.com ruchisono@gmail.com Aug 1, 2016 May 05, 2021 Everyone https://docs.google.com/document/d/1x-9reZuLRX... True False False 2021-06-16 12:59:19
2312943 Biliyor Musun - Sonsuz Yarış com.yyazilim.biliyormusun Trivia 5.0 12.0 100+ 100.0 354 True 0.0 ... NaN yyazilimdevelop@gmail.com Aug 9, 2019 Aug 19, 2019 Everyone https://biliyor-musun-sons.flycricket.io/priva... True False False 2021-06-16 12:59:19

5 rows × 24 columns

In [8]:
playstore[['Currency',
       'Size', 'Minimum Android', 'Developer Id']]
Out[8]:
Currency Size Minimum Android Developer Id
0 USD 10M 7.1 and up Jean Confident Irénée NIYIZIBYOSE
1 USD 2.9M 5.0 and up Webserveis
2 USD 3.7M 4.0.3 and up Cabin Crew
3 USD 1.8M 4.0.3 and up Climate Smart Tech2
4 USD 6.2M 4.1 and up Rafal Milek-Horodyski
... ... ... ... ...
2312939 USD 77M 4.1 and up ALICE GAME
2312940 USD 44M 4.1 and up 3Dream Studios, LLC
2312941 USD 29M 5.0 and up appoworld
2312942 USD 10M 5.0 and up Bhakti
2312943 USD 5.2M 5.0 and up Y Yazılım

2312944 rows × 4 columns

In [9]:
playstore.Category.unique()
Out[9]:
array(['Adventure', 'Tools', 'Productivity', 'Communication', 'Social',
       'Libraries & Demo', 'Lifestyle', 'Personalization', 'Racing',
       'Maps & Navigation', 'Travel & Local', 'Food & Drink',
       'Books & Reference', 'Medical', 'Puzzle', 'Entertainment',
       'Arcade', 'Auto & Vehicles', 'Photography', 'Health & Fitness',
       'Education', 'Shopping', 'Board', 'Music & Audio', 'Sports',
       'Beauty', 'Business', 'Educational', 'Finance', 'News & Magazines',
       'Casual', 'Art & Design', 'House & Home', 'Card', 'Events',
       'Trivia', 'Weather', 'Strategy', 'Word', 'Video Players & Editors',
       'Action', 'Simulation', 'Music', 'Dating', 'Role Playing',
       'Casino', 'Comics', 'Parenting'], dtype=object)
In [10]:
playstore.columns
Out[10]:
Index(['App Name', 'App Id', 'Category', 'Rating', 'Rating Count', 'Installs',
       'Minimum Installs', 'Maximum Installs', 'Free', 'Price', 'Currency',
       'Size', 'Minimum Android', 'Developer Id', 'Developer Website',
       'Developer Email', 'Released', 'Last Updated', 'Content Rating',
       'Privacy Policy', 'Ad Supported', 'In App Purchases', 'Editors Choice',
       'Scraped Time'],
      dtype='object')
In [11]:
playstore.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2312944 entries, 0 to 2312943
Data columns (total 24 columns):
 #   Column             Dtype  
---  ------             -----  
 0   App Name           object 
 1   App Id             object 
 2   Category           object 
 3   Rating             float64
 4   Rating Count       float64
 5   Installs           object 
 6   Minimum Installs   float64
 7   Maximum Installs   int64  
 8   Free               bool   
 9   Price              float64
 10  Currency           object 
 11  Size               object 
 12  Minimum Android    object 
 13  Developer Id       object 
 14  Developer Website  object 
 15  Developer Email    object 
 16  Released           object 
 17  Last Updated       object 
 18  Content Rating     object 
 19  Privacy Policy     object 
 20  Ad Supported       bool   
 21  In App Purchases   bool   
 22  Editors Choice     bool   
 23  Scraped Time       object 
dtypes: bool(4), float64(4), int64(1), object(15)
memory usage: 361.8+ MB
In [12]:
playstore.shape
Out[12]:
(2312944, 24)
In [13]:
playstore.describe()
Out[13]:
Rating Rating Count Minimum Installs Maximum Installs Price
count 2.290061e+06 2.290061e+06 2.312837e+06 2.312944e+06 2.312944e+06
mean 2.203152e+00 2.864839e+03 1.834452e+05 3.202017e+05 1.034992e-01
std 2.106223e+00 2.121626e+05 1.513144e+07 2.355495e+07 2.633127e+00
min 0.000000e+00 0.000000e+00 0.000000e+00 0.000000e+00 0.000000e+00
25% 0.000000e+00 0.000000e+00 5.000000e+01 8.400000e+01 0.000000e+00
50% 2.900000e+00 6.000000e+00 5.000000e+02 6.950000e+02 0.000000e+00
75% 4.300000e+00 4.200000e+01 5.000000e+03 7.354000e+03 0.000000e+00
max 5.000000e+00 1.385576e+08 1.000000e+10 1.205763e+10 4.000000e+02
In [14]:
playstore.describe(include = "object")
Out[14]:
App Name App Id Category Installs Currency Size Minimum Android Developer Id Developer Website Developer Email Released Last Updated Content Rating Privacy Policy Scraped Time
count 2312942 2312944 2312944 2312837 2312809 2312748 2306414 2312911 1552109 2312913 2241891 2312944 2312944 1891991 2312944
unique 2177944 2312944 48 22 15 1657 154 758371 810440 950456 4158 3918 6 977743 67374
top Tic Tac Toe com.ishakwe.gakondo Education 100+ USD Varies with device 4.1 and up Subsplash Inc http://www.subsplash.com/ support@classplus.co Jun 16, 2020 Jun 10, 2021 Everyone http://www.subsplash.com/legal/privacy 2021-06-16 07:35:57
freq 382 1 241090 443368 2311548 74777 604465 5422 7519 10345 2051 11186 2022089 7481 56
In [15]:
playstore.isna()
Out[15]:
App Name App Id Category Rating Rating Count Installs Minimum Installs Maximum Installs Free Price ... Developer Website Developer Email Released Last Updated Content Rating Privacy Policy Ad Supported In App Purchases Editors Choice Scraped Time
0 False False False False False False False False False False ... False False False False False False False False False False
1 False False False False False False False False False False ... False False False False False False False False False False
2 False False False False False False False False False False ... True False False False False False False False False False
3 False False False False False False False False False False ... False False False False False True False False False False
4 False False False False False False False False False False ... False False False False False False False False False False
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2312939 False False False False False False False False False False ... False False True False False False False False False False
2312940 False False False False False False False False False False ... False False False False False False False False False False
2312941 False False False False False False False False False False ... True False False False False False False False False False
2312942 False False False False False False False False False False ... False False False False False False False False False False
2312943 False False False False False False False False False False ... True False False False False False False False False False

2312944 rows × 24 columns

In [16]:
na_counts = playstore.isna().sum()
na_counts = na_counts.to_frame().reset_index()
na_counts.columns = ["col", "count"]
na_counts
Out[16]:
col count
0 App Name 2
1 App Id 0
2 Category 0
3 Rating 22883
4 Rating Count 22883
5 Installs 107
6 Minimum Installs 107
7 Maximum Installs 0
8 Free 0
9 Price 0
10 Currency 135
11 Size 196
12 Minimum Android 6530
13 Developer Id 33
14 Developer Website 760835
15 Developer Email 31
16 Released 71053
17 Last Updated 0
18 Content Rating 0
19 Privacy Policy 420953
20 Ad Supported 0
21 In App Purchases 0
22 Editors Choice 0
23 Scraped Time 0
In [17]:
gp= playstore[['App Name', 'Rating', 'Rating Count', 'Installs',
       'Minimum Installs', 'Currency', 'Size', 'Minimum Android', 'Developer Id', 'Developer Website',
       'Developer Email', 'Released','Privacy Policy']]
gp
Out[17]:
App Name Rating Rating Count Installs Minimum Installs Currency Size Minimum Android Developer Id Developer Website Developer Email Released Privacy Policy
0 Gakondo 0.0 0.0 10+ 10.0 USD 10M 7.1 and up Jean Confident Irénée NIYIZIBYOSE https://beniyizibyose.tk/#/ jean21101999@gmail.com Feb 26, 2020 https://beniyizibyose.tk/projects/
1 Ampere Battery Info 4.4 64.0 5,000+ 5000.0 USD 2.9M 5.0 and up Webserveis https://webserveis.netlify.app/ webserveis@gmail.com May 21, 2020 https://dev4phones.wordpress.com/licencia-de-uso/
2 Vibook 0.0 0.0 50+ 50.0 USD 3.7M 4.0.3 and up Cabin Crew NaN vnacrewit@gmail.com Aug 9, 2019 https://www.vietnamairlines.com/vn/en/terms-an...
3 Smart City Trichy Public Service Vehicles 17UC... 5.0 5.0 10+ 10.0 USD 1.8M 4.0.3 and up Climate Smart Tech2 http://www.climatesmarttech.com/ climatesmarttech2@gmail.com Sep 10, 2018 NaN
4 GROW.me 0.0 0.0 100+ 100.0 USD 6.2M 4.1 and up Rafal Milek-Horodyski http://www.horodyski.com.pl rmilekhorodyski@gmail.com Feb 21, 2020 http://www.horodyski.com.pl
... ... ... ... ... ... ... ... ... ... ... ... ... ...
2312939 大俠客—熱血歸來 4.3 16775.0 100,000+ 100000.0 USD 77M 4.1 and up ALICE GAME http://www.4399sy.com.hk/ ssjjcomhk@gmail.com NaN http://a.4399sy.com.hk/user/aggreement
2312940 ORU Online 0.0 0.0 100+ 100.0 USD 44M 4.1 and up 3Dream Studios, LLC http://www.oru.edu/ 3DreamDeveloper@gmail.com Jan 17, 2018 http://www.oru.edu/about-oru/privacy-policy.php
2312941 Data Structure 0.0 0.0 100+ 100.0 USD 29M 5.0 and up appoworld NaN appoworld.official@gmail.com Aug 19, 2018 https://appoworld.000webhostapp.com/datastruct...
2312942 Devi Suktam 3.5 8.0 1,000+ 1000.0 USD 10M 5.0 and up Bhakti https://a70f78905.app-ads-txt.com ruchisono@gmail.com Aug 1, 2016 https://docs.google.com/document/d/1x-9reZuLRX...
2312943 Biliyor Musun - Sonsuz Yarış 5.0 12.0 100+ 100.0 USD 5.2M 5.0 and up Y Yazılım NaN yyazilimdevelop@gmail.com Aug 9, 2019 https://biliyor-musun-sons.flycricket.io/priva...

2312944 rows × 13 columns

In [18]:
playstore.dropna(axis=0, inplace = True)
In [19]:
na_counts = playstore.isna().sum()
na_counts = na_counts.to_frame().reset_index()
na_counts.columns = ["col", "count"]
na_counts
Out[19]:
col count
0 App Name 0
1 App Id 0
2 Category 0
3 Rating 0
4 Rating Count 0
5 Installs 0
6 Minimum Installs 0
7 Maximum Installs 0
8 Free 0
9 Price 0
10 Currency 0
11 Size 0
12 Minimum Android 0
13 Developer Id 0
14 Developer Website 0
15 Developer Email 0
16 Released 0
17 Last Updated 0
18 Content Rating 0
19 Privacy Policy 0
20 Ad Supported 0
21 In App Purchases 0
22 Editors Choice 0
23 Scraped Time 0
In [20]:
playstore.describe(include = "object")
Out[20]:
App Name App Id Category Installs Currency Size Minimum Android Developer Id Developer Website Developer Email Released Last Updated Content Rating Privacy Policy Scraped Time
count 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191 1287191
unique 1245508 1287191 48 22 8 1563 106 452401 659753 561767 4154 3598 6 701772 67350
top Flashlight com.ishakwe.gakondo Education 100+ USD 11M 4.1 and up Subsplash Inc http://www.subsplash.com/ appsupport@subsplash.com Jun 24, 2020 Jun 10, 2021 Everyone http://www.subsplash.com/legal/privacy 2021-06-16 03:58:14
freq 127 1 127219 243612 1286647 37424 337652 5422 7518 7567 1156 6986 1122381 7468 40
In [21]:
playstore.shape
Out[21]:
(1287191, 24)
In [23]:
playstore.columns = playstore.columns.str.replace(" ", "_")
In [24]:
playstore.head()
Out[24]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Website Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time
0 Gakondo com.ishakwe.gakondo Adventure 0.0 0.0 10+ 10.0 15 True 0.0 ... https://beniyizibyose.tk/#/ jean21101999@gmail.com Feb 26, 2020 Feb 26, 2020 Everyone https://beniyizibyose.tk/projects/ False False False 2021-06-15 20:19:35
1 Ampere Battery Info com.webserveis.batteryinfo Tools 4.4 64.0 5,000+ 5000.0 7662 True 0.0 ... https://webserveis.netlify.app/ webserveis@gmail.com May 21, 2020 May 06, 2021 Everyone https://dev4phones.wordpress.com/licencia-de-uso/ True False False 2021-06-15 20:19:35
4 GROW.me com.horodyski.grower Tools 0.0 0.0 100+ 100.0 478 True 0.0 ... http://www.horodyski.com.pl rmilekhorodyski@gmail.com Feb 21, 2020 Nov 12, 2018 Everyone http://www.horodyski.com.pl False False False 2021-06-15 20:19:35
5 IMOCCI com.imocci Social 0.0 0.0 50+ 50.0 89 True 0.0 ... http://www.imocci.com info@imocci.com Dec 24, 2018 Dec 20, 2019 Teen https://www.imocci.com/wp-content/uploads/2018... False True False 2021-06-15 20:19:35
9 Neon 3d Iron Tech Keyboard Theme com.ikeyboard.theme.neon_3d.iron.tech Personalization 4.7 820.0 50,000+ 50000.0 62433 True 0.0 ... https://trendyteme888-31139.web.app trendyteme.888@gmail.com Sep 22, 2019 Oct 07, 2020 Everyone http://bit.ly/EmojiThemePro True False False 2021-06-15 20:19:35

5 rows × 24 columns

In [25]:
playstore.Currency.unique()
Out[25]:
array(['USD', 'XXX', 'VND', 'GBP', 'INR', 'TRY', 'EUR', 'ZAR'],
      dtype=object)
In [26]:
playstore.Installs.unique()
Out[26]:
array(['10+', '5,000+', '100+', '50+', '50,000+', '10,000+', '1,000+',
       '500+', '500,000+', '100,000+', '10,000,000+', '1+', '1,000,000+',
       '5+', '5,000,000+', '100,000,000+', '0+', '50,000,000+',
       '1,000,000,000+', '500,000,000+', '5,000,000,000+',
       '10,000,000,000+'], dtype=object)
In [27]:
playstore.Content_Rating.unique()
Out[27]:
array(['Everyone', 'Teen', 'Everyone 10+', 'Mature 17+',
       'Adults only 18+', 'Unrated'], dtype=object)
In [28]:
playstore.Category.unique()
Out[28]:
array(['Adventure', 'Tools', 'Social', 'Personalization',
       'Maps & Navigation', 'Travel & Local', 'Food & Drink', 'Puzzle',
       'Entertainment', 'Photography', 'Health & Fitness', 'Shopping',
       'Books & Reference', 'Beauty', 'Business', 'Educational',
       'Lifestyle', 'Music & Audio', 'News & Magazines',
       'Auto & Vehicles', 'Productivity', 'Education', 'Art & Design',
       'House & Home', 'Racing', 'Sports', 'Events', 'Finance', 'Weather',
       'Board', 'Medical', 'Communication', 'Word', 'Action', 'Trivia',
       'Simulation', 'Video Players & Editors', 'Music', 'Arcade',
       'Libraries & Demo', 'Casual', 'Dating', 'Strategy', 'Card',
       'Role Playing', 'Casino', 'Parenting', 'Comics'], dtype=object)
In [29]:
playstore.App_Name.unique()
Out[29]:
array(['Gakondo', 'Ampere Battery Info', 'GROW.me', ...,
       'Caustic Editor for VolcaSample', 'Lero TOEFL Recorder + Timer',
       'ORU Online'], dtype=object)
In [30]:
playstore.Category.value_counts()
Out[30]:
Education                  127219
Business                   100311
Music & Audio               87008
Lifestyle                   75017
Tools                       67215
Entertainment               63581
Books & Reference           56515
Health & Fitness            51770
Shopping                    48981
Productivity                46960
Travel & Local              46613
Food & Drink                45773
Finance                     44111
Personalization             37819
Communication               30703
News & Magazines            29320
Sports                      29180
Social                      27164
Puzzle                      25069
Casual                      21958
Medical                     20260
Arcade                      19925
Photography                 16827
Maps & Navigation           15821
Educational                 13048
Simulation                  12569
Action                      12385
Auto & Vehicles             10744
Adventure                   10295
House & Home                 8707
Events                       8497
Art & Design                 8007
Video Players & Editors      6883
Beauty                       6179
Trivia                       5885
Role Playing                 5711
Racing                       5383
Board                        5175
Word                         4989
Card                         4858
Strategy                     4117
Weather                      4103
Dating                       3429
Casino                       2810
Parenting                    2381
Libraries & Demo             2371
Music                        2200
Comics                       1345
Name: Category, dtype: int64
In [31]:
#Question 1 (Top 5 Categories of Apps)
df = playstore.Category.rename_axis("Category").value_counts().reset_index(name = "counts").head()
df
Out[31]:
index counts
0 Education 127219
1 Business 100311
2 Music & Audio 87008
3 Lifestyle 75017
4 Tools 67215
In [32]:
fig= px.bar(df,y="counts",x="index")
fig.show()
In [33]:
#Question 2(Most Expensive App)
playstore[playstore["Price"] == 400]
Out[33]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Website Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time
544468 MESH Connect com.tecit.android.bluepiano.meshconnectfull Productivity 0.0 0.0 10+ 10.0 25 False 400.0 ... http://www.go-evo.com support@go-evo.com Sep 7, 2017 Sep 07, 2017 Everyone http://www.go-evo.com/privacy False False False 2021-06-16 05:15:22

1 rows × 24 columns

In [34]:
#Question 3(High Rated App)
playstore[playstore["Rating"] == 5]
Out[34]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Website Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time
116 ignite com.torch.ignite Events 5.0 21.0 100+ 100.0 224 True 0.0 ... http://www.peilee.com asdfg3865@gmail.com Jun 22, 2018 Jul 04, 2018 Everyone https://alvinyang10919058.wixsite.com/privacyp... False False False 2021-06-15 20:19:42
169 San Jose Gurdwara sanjose.gurdwara.com.sanjosegurdwara Social 5.0 10.0 500+ 500.0 779 True 0.0 ... http://sanjosegurdwara.org swapna.jadhav14@gmail.com Apr 8, 2018 Aug 20, 2019 Everyone http://sanjosegurdwara.org/privacy_policy.html False False False 2021-06-15 20:19:45
290 Tekman Batur appinventor.ai_ttaslicay.TekmanBatur Travel & Local 5.0 5.0 50+ 50.0 51 True 0.0 ... https://tekmanbatur.blogspot.com/ kazakmedya@gmail.com May 14, 2020 May 19, 2020 Everyone https://tekmanbatur.blogspot.com/p/gizlilik-po... False False False 2021-06-15 20:19:53
329 Fazzaco com.stl.fazzaco Business 5.0 156.0 10,000+ 10000.0 11354 True 0.0 ... https://www.fazzaco.com/ service@fazzaco.com Jun 9, 2020 May 17, 2021 Everyone https://www.fazzaco.com/getPrivacyAgreement True False False 2021-06-15 20:19:55
410 POOL CAR APP com.mpowercab.mpowercab Education 5.0 5.0 50+ 50.0 58 True 0.0 ... http://beingwireless.in/ beingwireless@gmail.com Dec 9, 2019 Dec 09, 2019 Everyone http://beingwireless.in/privacy.html False False False 2021-06-15 20:20:00
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2312767 Quintero Asociados co.grupoata.quinteroasociados Productivity 5.0 5.0 50+ 50.0 82 True 0.0 ... http://www.grupoata.co info@grupoata.co Sep 26, 2018 Dec 16, 2020 Everyone http://grupoata.co/politica-informacion.html False False False 2021-06-16 12:59:09
2312783 France Bycott com.developerworkerz.francebycot Social 5.0 22.0 10+ 10.0 40 True 0.0 ... https://loopahoption.wixsite.com/france-boycott usamaahmedsunny@gmail.com Nov 10, 2020 Nov 17, 2020 Everyone https://loopahoption.wixsite.com/france-boycott True False False 2021-06-16 12:59:10
2312815 Buy Tiffin com.buytiffin Food & Drink 5.0 59.0 500+ 500.0 511 True 0.0 ... https://buytiffin.in info@buytiffin.in Aug 3, 2019 Feb 17, 2020 Everyone https://buytiffin.in/privacy-policy-for-app/ False False False 2021-06-16 12:59:12
2312880 Crown Office bazaar com.crown_office_bazaar.crown0fficebazaar Business 5.0 5.0 50+ 50.0 51 True 0.0 ... https://www.crownofficebazaar.com/ support@crownofficebazaar.com Sep 6, 2020 Sep 29, 2020 Everyone http://www.crownofficebazaar.com/privacy-policy False False False 2021-06-16 12:59:15
2312909 Century College com.readyeducation.centurycollege Education 5.0 10.0 100+ 100.0 230 True 0.0 ... https://www.readyeducation.com support@readyeducation.com Aug 26, 2020 May 24, 2021 Everyone https://www.readyeducation.com/privacy False False False 2021-06-16 12:59:17

52774 rows × 24 columns

In [35]:
playstore[playstore["Rating"] == 5.0]
Out[35]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Website Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time
116 ignite com.torch.ignite Events 5.0 21.0 100+ 100.0 224 True 0.0 ... http://www.peilee.com asdfg3865@gmail.com Jun 22, 2018 Jul 04, 2018 Everyone https://alvinyang10919058.wixsite.com/privacyp... False False False 2021-06-15 20:19:42
169 San Jose Gurdwara sanjose.gurdwara.com.sanjosegurdwara Social 5.0 10.0 500+ 500.0 779 True 0.0 ... http://sanjosegurdwara.org swapna.jadhav14@gmail.com Apr 8, 2018 Aug 20, 2019 Everyone http://sanjosegurdwara.org/privacy_policy.html False False False 2021-06-15 20:19:45
290 Tekman Batur appinventor.ai_ttaslicay.TekmanBatur Travel & Local 5.0 5.0 50+ 50.0 51 True 0.0 ... https://tekmanbatur.blogspot.com/ kazakmedya@gmail.com May 14, 2020 May 19, 2020 Everyone https://tekmanbatur.blogspot.com/p/gizlilik-po... False False False 2021-06-15 20:19:53
329 Fazzaco com.stl.fazzaco Business 5.0 156.0 10,000+ 10000.0 11354 True 0.0 ... https://www.fazzaco.com/ service@fazzaco.com Jun 9, 2020 May 17, 2021 Everyone https://www.fazzaco.com/getPrivacyAgreement True False False 2021-06-15 20:19:55
410 POOL CAR APP com.mpowercab.mpowercab Education 5.0 5.0 50+ 50.0 58 True 0.0 ... http://beingwireless.in/ beingwireless@gmail.com Dec 9, 2019 Dec 09, 2019 Everyone http://beingwireless.in/privacy.html False False False 2021-06-15 20:20:00
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2312767 Quintero Asociados co.grupoata.quinteroasociados Productivity 5.0 5.0 50+ 50.0 82 True 0.0 ... http://www.grupoata.co info@grupoata.co Sep 26, 2018 Dec 16, 2020 Everyone http://grupoata.co/politica-informacion.html False False False 2021-06-16 12:59:09
2312783 France Bycott com.developerworkerz.francebycot Social 5.0 22.0 10+ 10.0 40 True 0.0 ... https://loopahoption.wixsite.com/france-boycott usamaahmedsunny@gmail.com Nov 10, 2020 Nov 17, 2020 Everyone https://loopahoption.wixsite.com/france-boycott True False False 2021-06-16 12:59:10
2312815 Buy Tiffin com.buytiffin Food & Drink 5.0 59.0 500+ 500.0 511 True 0.0 ... https://buytiffin.in info@buytiffin.in Aug 3, 2019 Feb 17, 2020 Everyone https://buytiffin.in/privacy-policy-for-app/ False False False 2021-06-16 12:59:12
2312880 Crown Office bazaar com.crown_office_bazaar.crown0fficebazaar Business 5.0 5.0 50+ 50.0 51 True 0.0 ... https://www.crownofficebazaar.com/ support@crownofficebazaar.com Sep 6, 2020 Sep 29, 2020 Everyone http://www.crownofficebazaar.com/privacy-policy False False False 2021-06-16 12:59:15
2312909 Century College com.readyeducation.centurycollege Education 5.0 10.0 100+ 100.0 230 True 0.0 ... https://www.readyeducation.com support@readyeducation.com Aug 26, 2020 May 24, 2021 Everyone https://www.readyeducation.com/privacy False False False 2021-06-16 12:59:17

52774 rows × 24 columns

In [36]:
#Question 5 (Oldest App on the Playstore)
playstore['Released_New'] = pd.to_datetime(playstore['Released']).dt.date
playstore['Released_New']
Out[36]:
0          2020-02-26
1          2020-05-21
4          2020-02-21
5          2018-12-24
9          2019-09-22
              ...    
2312933    2014-12-11
2312934    2020-06-15
2312938    2018-05-22
2312940    2018-01-17
2312942    2016-08-01
Name: Released_New, Length: 1287191, dtype: object
In [37]:
playstore['Released_New'].min()
Out[37]:
datetime.date(2010, 1, 28)
In [34]:
playstore[playstore['Released_New']==playstore['Released_New'].min()]
Out[34]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New
1005858 Packing List com.dotnetideas.packinglist Travel & Local 4.0 965.0 100,000+ 100000.0 250363 True 0.00 ... support@dotnetideas.com Jan 28, 2010 Aug 07, 2019 Everyone https://www.dotnetideas.com/home/PrivacyPolicy True False False 2021-06-16 12:24:26 2010-01-28
1286316 Pubtran cz.fhejl.pubtran Maps & Navigation 4.6 24248.0 1,000,000+ 1000000.0 1047316 True 0.00 ... jizdnirady@firma.seznam.cz Jan 28, 2010 Jan 14, 2021 Everyone https://napoveda.seznam.cz/en/personal-data-pr... False False False 2021-06-15 21:58:38 2010-01-28
1303450 TweetCaster for Twitter com.handmark.tweetcaster Social 4.0 517738.0 10,000,000+ 10000000.0 11884201 True 0.00 ... support@onelouder.com Jan 28, 2010 Feb 28, 2021 Teen http://tweetcaster.com/privacy True True False 2021-06-15 22:13:37 2010-01-28
2052352 TweetCaster Pro for Twitter com.handmark.tweetcaster.premium Social 3.9 24284.0 100,000+ 100000.0 102129 False 4.99 ... support@onelouder.com Jan 28, 2010 Mar 02, 2021 Teen http://tweetcaster.com/privacy False False False 2021-06-16 09:11:58 2010-01-28
2285011 VIP Access com.verisign.mvip.main Tools 4.0 15679.0 5,000,000+ 5000000.0 6775296 True 0.00 ... vip.mobilesupport@broadcom.com Jan 28, 2010 Nov 18, 2019 Everyone https://www.symantec.com/privacy False False False 2021-06-16 12:34:40 2010-01-28

5 rows × 25 columns

In [22]:
#Question 4 (Max installed App)
playstore.Maximum_Installs.max()
---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
~\AppData\Local\Temp/ipykernel_10624/2089670649.py in <module>
      1 #Question 4 (Max installed App)
----> 2 playstore.Maximum_Installs.max()

~\anaconda3\lib\site-packages\pandas\core\generic.py in __getattr__(self, name)
   5485         ):
   5486             return self[name]
-> 5487         return object.__getattribute__(self, name)
   5488 
   5489     def __setattr__(self, name: str, value) -> None:

AttributeError: 'DataFrame' object has no attribute 'Maximum_Installs'
In [36]:
#12057627016
playstore[playstore["Maximum_Installs"] == 12057627016] 
Out[36]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New
2155096 Google Play services com.google.android.gms Tools 4.2 35128398.0 10,000,000,000+ 1.000000e+10 12057627016 True 0.0 ... apps-help@google.com May 24, 2012 Jun 10, 2021 Everyone http://www.google.com/policies/privacy False False False 2021-06-16 10:41:26 2012-05-24

1 rows × 25 columns

In [37]:
#1.205763e+10
playstore.describe()
Out[37]:
Rating Rating_Count Minimum_Installs Maximum_Installs Price
count 1.287191e+06 1.287191e+06 1.287191e+06 1.287191e+06 1.287191e+06
mean 2.315500e+00 4.470702e+03 2.691305e+05 4.676076e+05 1.099716e-01
std 2.090373e+00 2.594790e+05 1.834388e+07 2.780474e+07 2.438043e+00
min 0.000000e+00 0.000000e+00 0.000000e+00 0.000000e+00 0.000000e+00
25% 0.000000e+00 0.000000e+00 1.000000e+02 1.150000e+02 0.000000e+00
50% 3.300000e+00 7.000000e+00 5.000000e+02 9.490000e+02 0.000000e+00
75% 4.300000e+00 6.100000e+01 1.000000e+04 1.074300e+04 0.000000e+00
max 5.000000e+00 1.385576e+08 1.000000e+10 1.205763e+10 4.000000e+02
In [38]:
#Question 7(Rating Analysis, Distribution of App Ratings)
fig= px.histogram(playstore,x="Rating")
fig.show()
In [39]:
#Qusetion 6(Ratio of apps that supported ads & that don't)
print(playstore.Ad_Supported.value_counts())
Ads = playstore.Ad_Supported.value_counts(normalize=True)*100
Ads
False    712073
True     575118
Name: Ad_Supported, dtype: int64
Out[39]:
False    55.319918
True     44.680082
Name: Ad_Supported, dtype: float64
In [40]:
575118/712073
Out[40]:
0.8076671914255982
In [41]:
fig= px.pie(Ads,values="Ad_Supported",names=['False', 'True'],color_discrete_sequence=px.colors.sequential.RdBu)
fig.show()
In [42]:
#Question 8 (List of All Shooting games within Playstore data)
category=playstore[playstore.Category=='Action']
category
Out[42]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New
221 John Brick com.AppsBergman.JohnBrick Action 3.9 11.0 500+ 500.0 522 True 0.0 ... contato@appsbergman.com Mar 19, 2021 Mar 22, 2021 Teen http://appsbergman.com/privacy_policy.html True False False 2021-06-15 20:19:49 2021-03-19
504 Balloon Popper com.aplications.adimov.balonkids Action 4.8 19.0 100+ 100.0 153 True 0.0 ... adimov742@gmail.com Dec 28, 2018 Mar 31, 2021 Everyone https://sites.google.com/view/mypolicypri/p%C3... True False False 2021-06-15 20:20:05 2018-12-28
811 Imran Khan vs Nawaz Sharif com.mypolitician.appdata.juni1289 Action 4.0 21.0 5,000+ 5000.0 8582 True 0.0 ... extremecode1289@gmail.com Sep 7, 2016 Jun 05, 2017 Everyone https://extremecodeblog.wordpress.com/privacy-... True False False 2021-06-15 20:20:22 2016-09-07
920 Counter Strike Shooting Game: Special Ops Shoo... com.ea.usarmy.counter.strike.shooting Action 4.7 979.0 100,000+ 100000.0 117176 True 0.0 ... contact.epiphanyatelier1@gmail.com May 7, 2020 May 11, 2021 Teen https://docs.google.com/document/d/1XneMJYLpTF... True False False 2021-06-15 20:20:29 2020-05-07
1593 Running Stick com.zplay.runningstick Action 4.0 156.0 10,000+ 10000.0 34691 True 0.0 ... contact@zplay.com Jun 19, 2017 Aug 04, 2017 Everyone http://games.zplay.com/en/ZplayPrivacyPolicy.html True False False 2021-06-15 20:21:08 2017-06-19
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2311750 Paintball Shooter 3D com.clashgamez.paintball.shooter3d.fighting.arena Action 2.8 1220.0 100,000+ 100000.0 292578 True 0.0 ... clashgamezstudio@gmail.com Dec 5, 2019 Feb 12, 2020 Everyone 10+ https://docs.google.com/document/d/1Ex8nIfNDgW... True False False 2021-06-16 12:58:16 2019-12-05
2312067 Battle Royale Fire Prime Free: Online & Offline com.firstanvilgames.battle.shooter.fps.Battleg... Action 3.9 2944.0 100,000+ 100000.0 450941 True 0.0 ... 20starteam20@gmail.com Apr 1, 2021 May 21, 2021 Teen https://docs.google.com/document/d/1ShDk_QIv54... True True False 2021-06-16 12:58:32 2021-04-01
2312357 Last Saber com.gempack.troops Action 3.5 22.0 1,000+ 1000.0 4716 True 0.0 ... contact@gempack.co.kr Sep 14, 2018 Feb 04, 2021 Everyone http://www.gempack.kr/privacy_policy/last_sabe... True False False 2021-06-16 12:58:47 2018-09-14
2312557 Funny Mercenary - MOBA DOTA com.MagicCard.FunnyMercenary Action 0.0 0.0 5,000+ 5000.0 7343 True 0.0 ... magiccard2005@gmail.com Dec 7, 2016 Jul 31, 2020 Teen https://funny-mercenary.flycricket.io/privacy.... True True False 2021-06-16 12:58:58 2016-12-07
2312932 Hopeless 2: Cave Escape com.upopa.hopeless2 Action 4.3 103466.0 5,000,000+ 5000000.0 7274660 True 0.0 ... support@upopa.com Oct 29, 2015 Mar 06, 2017 Teen http://www.upopa.com/games/hopeless2/privacypo... True True False 2021-06-16 12:59:18 2015-10-29

12385 rows × 25 columns

In [43]:
category[category.App_Name.str.contains("kill|shoot|war|fight|crime|action")]
Out[43]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New
2736 Counter FPS shooting strike: New shooting games com.sfgs.counter.shooting.strike.shooting.games Action 4.1 79.0 10,000+ 10000.0 20199 True 0.00 ... sunshinefightinggames@yahoo.com Apr 25, 2020 Apr 25, 2020 Teen https://sites.google.com/view/sunshine-freegam... True False False 2021-06-15 20:22:13 2020-04-25
5086 Blocky Cars - pixel shooter & tank wars com.blockycars.online Action 4.4 428863.0 10,000,000+ 10000000.0 25055030 True 0.00 ... blocky.cars@fullhpltd.com Jul 10, 2015 Apr 22, 2021 Everyone 10+ http://fullhpltd.com/this-privacy-policy/ True True False 2021-06-15 20:24:29 2015-07-10
19145 Z.O.N.A Project X - Post-apocalyptic shooter. com.agaming.zonaprojectx Action 3.0 8167.0 100,000+ 100000.0 234719 False 0.99 ... agamingandroid@gmail.com Aug 22, 2015 Nov 15, 2019 Mature 17+ http://eagaming.org/pages/privacy-policy-googl... False False False 2021-06-15 20:38:17 2015-08-22
21490 Zombie Smasher Squad: Deadly Roadkill Car Surv... com.futurealiti.zombie.smasher.squad.deadly.ro... Action 4.4 7.0 1,000+ 1000.0 1980 True 0.00 ... devaccounts@futurealiti.com Apr 10, 2020 Apr 25, 2020 Teen https://futurealiti.com/privacy-policy/ True True False 2021-06-15 20:40:33 2020-04-10
23512 HumV Dogs Legend : Offline cartoon racing action com.guris.humvdogslegend Action 4.4 45.0 10,000+ 10000.0 12953 True 0.00 ... searoopy@gmail.com Jun 29, 2020 Feb 08, 2021 Everyone https://passman.tistory.com/category/DFFFFF True True False 2021-06-15 20:42:32 2020-06-29
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2285069 Pot shooter com.cybearcode.potshooter Action 0.0 0.0 1,000+ 1000.0 1678 True 0.00 ... contact@cybearcode.com Apr 14, 2021 May 31, 2021 Everyone https://cybearcode.com/privacy-policy True True False 2021-06-16 12:34:43 2021-04-14
2288356 army fight com.virtualinfocom.army.fight Action 4.0 24.0 1,000+ 1000.0 2745 True 0.00 ... arijit79in@gmail.com Feb 15, 2017 Aug 02, 2018 Teen http://ani2pix.com/policy.html True False False 2021-06-16 12:37:39 2017-02-15
2291282 One Gun 2 Stickman rpg shooter gang com.erow.stickgun2 Action 4.4 367.0 100,000+ 100000.0 435844 True 0.00 ... erowhelp@gmail.com Jul 9, 2019 Jun 15, 2021 Everyone 10+ https://erowdev-ffb62.firebaseapp.com/privacy_... True True False 2021-06-16 12:40:11 2019-07-09
2295188 Star Forces: Space shooter com.azurinteractive.StarForces Action 3.3 11110.0 1,000,000+ 1000000.0 1022390 True 0.00 ... zar@azurgames.com Feb 21, 2019 Apr 02, 2019 Teen https://privacy.azurgames.com True True False 2021-06-16 12:43:37 2019-02-21
2311434 Superhero fighter king: Spider Fighting games com.epic_games.superhero.fighter.king Action 4.9 221.0 10,000+ 10000.0 24287 True 0.00 ... epicgamesworld40@gmail.com Sep 5, 2019 Jul 06, 2020 Teen https://epicgamesworld.weebly.com/ True False False 2021-06-16 12:58:00 2019-09-05

355 rows × 25 columns

In [44]:
#Question 9 (Rating Analysis in each category of apps(Top 3))
playstore.Category.value_counts()
Out[44]:
Education                  127219
Business                   100311
Music & Audio               87008
Lifestyle                   75017
Tools                       67215
Entertainment               63581
Books & Reference           56515
Health & Fitness            51770
Shopping                    48981
Productivity                46960
Travel & Local              46613
Food & Drink                45773
Finance                     44111
Personalization             37819
Communication               30703
News & Magazines            29320
Sports                      29180
Social                      27164
Puzzle                      25069
Casual                      21958
Medical                     20260
Arcade                      19925
Photography                 16827
Maps & Navigation           15821
Educational                 13048
Simulation                  12569
Action                      12385
Auto & Vehicles             10744
Adventure                   10295
House & Home                 8707
Events                       8497
Art & Design                 8007
Video Players & Editors      6883
Beauty                       6179
Trivia                       5885
Role Playing                 5711
Racing                       5383
Board                        5175
Word                         4989
Card                         4858
Strategy                     4117
Weather                      4103
Dating                       3429
Casino                       2810
Parenting                    2381
Libraries & Demo             2371
Music                        2200
Comics                       1345
Name: Category, dtype: int64
In [45]:
# Education, Business, Music & Audio
df1 = playstore.Category.value_counts().reset_index(name = "counts").head(3)
df1
Out[45]:
index counts
0 Education 127219
1 Business 100311
2 Music & Audio 87008
In [46]:
fig= px.histogram(playstore[playstore.Category=='Education'],x="Rating")
fig.show()
In [47]:
fig= px.histogram(playstore[playstore.Category=='Business'],x="Rating")
fig.show()
In [48]:
fig= px.histogram(playstore[playstore.Category=='Music & Audio'],x="Rating")
fig.show()
In [49]:
#Question 13(Last Updated App in the Playstore)
playstore['Last_Updated_New'] = pd.to_datetime(playstore['Last_Updated']).dt.date
playstore['Last_Updated_New']
Out[49]:
0          2020-02-26
1          2021-05-06
4          2018-11-12
5          2019-12-20
9          2020-10-07
              ...    
2312933    2014-12-11
2312934    2020-08-31
2312938    2018-12-14
2312940    2018-02-02
2312942    2021-05-05
Name: Last_Updated_New, Length: 1287191, dtype: object
In [50]:
playstore['Last_Updated_New'].max()
Out[50]:
datetime.date(2021, 6, 16)
In [51]:
playstore[playstore['Last_Updated_New']==playstore['Last_Updated_New'].max()]
Out[51]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New Last_Updated_New
309976 Simplify Fitness com.trainerize.simplifyfitness Health & Fitness 0.0 0.0 1+ 1.0 4 True 0.0 ... Nov 16, 2017 Jun 16, 2021 Everyone http://www.trainerize.com/privacy.aspx False False False 2021-06-16 01:38:59 2017-11-16 2021-06-16
316480 SUSS Reader sg.edu.suss.etp.sreader2 Education 1.7 7.0 1,000+ 1000.0 1604 True 0.0 ... Aug 29, 2019 Jun 16, 2021 Everyone http://www.suss.edu.sg/Pages/Privacy-Policy.aspx False False False 2021-06-16 01:45:34 2019-08-29 2021-06-16
339988 Field Pro by ION Solar com.ionsolar.fieldpro Tools 0.0 0.0 100+ 100.0 256 True 0.0 ... Jun 26, 2019 Jun 16, 2021 Everyone https://ionsolar.com/privacy/ False False False 2021-06-16 02:08:13 2019-06-26 2021-06-16
340610 BreakOut - Video Conference,Meeting,Seminar com.haedenbridge.moyeee.meeting Business 3.3 52.0 10,000+ 10000.0 30709 True 0.0 ... Nov 1, 2018 Jun 16, 2021 Everyone http://www.breakout.cloud/policy/kr/privacy.html False False False 2021-06-16 02:08:49 2018-11-01 2021-06-16
343467 Grow Soldier - Merge Soldier com.pixelstar.GrowSoldier Adventure 3.8 1438.0 100,000+ 100000.0 326701 True 0.0 ... Jan 30, 2019 Jun 16, 2021 Teen https://pixelstargames.blogspot.com/ True True False 2021-06-16 02:11:35 2019-01-30 2021-06-16
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2310083 Al Rifai Arabia com.alrifaiarabia Business 3.4 65.0 10,000+ 10000.0 36456 True 0.0 ... Sep 27, 2020 Jun 16, 2021 Everyone https://alrifaiarabia.com/privacy-policy False False False 2021-06-16 12:56:49 2020-09-27 2021-06-16
2310879 I'm home アイムホーム com.audiencemedia.app465.issue3491 Art & Design 0.0 0.0 5+ 5.0 6 True 0.0 ... May 20, 2019 Jun 16, 2021 Everyone https://www.shotenkenchiku.com/guide/privacy.php True True False 2021-06-16 12:57:31 2019-05-20 2021-06-16
2311575 4 Images 1 Mot de.lotum.whatsinthefoto.fr Word 4.4 384932.0 10,000,000+ 10000000.0 19549176 True 0.0 ... Dec 22, 2016 Jun 16, 2021 Everyone 10+ https://lotum.com/privacy-policy.html True True False 2021-06-16 12:58:07 2016-12-22 2021-06-16
2311589 Fake call - Girlfriend Prank com.sexygirl.videocall.prank Entertainment 2.8 6.0 100,000+ 100000.0 109986 True 0.0 ... Jan 4, 2021 Jun 16, 2021 Mature 17+ https://sites.google.com/view/thezeeapp True False False 2021-06-16 12:58:08 2021-01-04 2021-06-16
2312454 AppTCC rouenwebmaster.mobile.apptoc Medical 5.0 7.0 1,000+ 1000.0 1478 True 0.0 ... Nov 8, 2019 Jun 16, 2021 Everyone https://apptoc.fr/politique-de-confidentialite/ False False False 2021-06-16 12:58:52 2019-11-08 2021-06-16

1131 rows × 26 columns

In [52]:
#Question 15(Find all Apps by Google)
playstore.columns
Out[52]:
Index(['App_Name', 'App_Id', 'Category', 'Rating', 'Rating_Count', 'Installs',
       'Minimum_Installs', 'Maximum_Installs', 'Free', 'Price', 'Currency',
       'Size', 'Minimum_Android', 'Developer_Id', 'Developer_Website',
       'Developer_Email', 'Released', 'Last_Updated', 'Content_Rating',
       'Privacy_Policy', 'Ad_Supported', 'In_App_Purchases', 'Editors_Choice',
       'Scraped_Time', 'Released_New', 'Last_Updated_New'],
      dtype='object')
In [53]:
playstore[['Developer_Id', 'Developer_Website',
       'Developer_Email']]
Out[53]:
Developer_Id Developer_Website Developer_Email
0 Jean Confident Irénée NIYIZIBYOSE https://beniyizibyose.tk/#/ jean21101999@gmail.com
1 Webserveis https://webserveis.netlify.app/ webserveis@gmail.com
4 Rafal Milek-Horodyski http://www.horodyski.com.pl rmilekhorodyski@gmail.com
5 Imocci GmbH http://www.imocci.com info@imocci.com
9 Free 2021 Themes for Emoji keyboard https://trendyteme888-31139.web.app trendyteme.888@gmail.com
... ... ... ...
2312933 Single Cell Software http://www.singlecellsoftware.com causticapp@gmail.com
2312934 Eliminates Apps https://af24d8239.app-ads-txt.com eliminatesapps@gmail.com
2312938 Julio Augusto Vera https://lerodoe.wordpress.com/ lero.doe@gmail.com
2312940 3Dream Studios, LLC http://www.oru.edu/ 3DreamDeveloper@gmail.com
2312942 Bhakti https://a70f78905.app-ads-txt.com ruchisono@gmail.com

1287191 rows × 3 columns

In [54]:
playstore[['Developer_Id', 'Developer_Website',
       'Developer_Email']][playstore[['Developer_Id', 'Developer_Website',
       'Developer_Email']].Developer_Id.str.contains("Google|google")]
Out[54]:
Developer_Id Developer_Website Developer_Email
10720 Google Certified Developer - Mayank Sharma https://android-breakdown.web.app HowdyMayank@gmail.com
13460 ScaledAgile Google Developer https://www.scaledagile.com/ support@scaledagile.com
23816 Google Dev Blacboard http://www.parentlink.net support@parentlink.net
26145 Google LLC http://www.android.com/ apps-help@google.com
29448 Google LLC http://eyes-free.googlecode.com/ apps-help@google.com
... ... ... ...
2261840 Google LLC http://support.google.com/wearos apps-help@google.com
2271911 Google LLC https://support.google.com/richmedia/answer/28... apps-help@google.com
2300539 Google LLC http://toontastic.com apps-help@google.com
2305532 Google LLC https://pay.google.com/about google-payments@google.com
2307317 Google LLC https://support.google.com/accounts/bin/answer... accounts-support@google.com

224 rows × 3 columns

In [55]:
playstore[playstore.Developer_Id.str.contains("Google|google")]
Out[55]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New Last_Updated_New
10720 Finance Records : Personal Finance & Money Man... com.mayank.financerecords Finance 4.5 11.0 100+ 100.0 286 True 0.0 ... Dec 22, 2020 Feb 20, 2021 Everyone https://privacypolicy-mayadi.blogspot.com/p/fi... False False False 2021-06-15 20:30:03 2020-12-22 2021-02-20
13460 SAFe Community Mobile com.follow.SAFeCommunity Education 2.9 16.0 1,000+ 1000.0 4648 True 0.0 ... May 30, 2019 Feb 09, 2021 Teen https://www.scaledagile.com/privacy-policy/ False False False 2021-06-15 20:32:40 2019-05-30 2021-02-09
23816 Corcoran USD net.parentlink.corcoran Education 4.2 8.0 100+ 100.0 396 True 0.0 ... Aug 6, 2014 Oct 23, 2020 Everyone http://www.blackboard.com/legal/privacy-securi... False False False 2021-06-15 20:42:49 2014-08-06 2020-10-23
26145 VR180 com.google.vr.eva Photography 4.1 635.0 100,000+ 100000.0 153207 True 0.0 ... May 3, 2018 Dec 06, 2019 Everyone http://www.google.com/policies/privacy False False False 2021-06-15 20:45:11 2018-05-03 2019-12-06
29448 Google BrailleBack com.googlecode.eyesfree.brailleback Tools 4.2 2599.0 100,000+ 100000.0 231880 True 0.0 ... Jun 27, 2012 Jun 10, 2020 Everyone http://www.google.com/policies/privacy False False False 2021-06-15 20:48:41 2012-06-27 2020-06-10
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2261840 Wear OS by Google Smartwatch com.google.android.wearable.app Communication 3.7 244914.0 10,000,000+ 10000000.0 30883699 True 0.0 ... Jul 2, 2014 Jun 15, 2021 Everyone http://www.google.com/policies/privacy False False False 2021-06-16 12:14:20 2014-07-02 2021-06-15
2271911 Creative Preview com.google.android.apps.audition Tools 4.4 1166.0 100,000+ 100000.0 154285 True 0.0 ... Mar 4, 2015 Jul 22, 2019 Everyone http://www.google.com/policies/privacy False False False 2021-06-16 12:23:11 2015-03-04 2019-07-22
2300539 Toontastic 3D com.google.toontastic Educational 4.1 44501.0 1,000,000+ 1000000.0 3325275 True 0.0 ... Jan 11, 2017 Nov 02, 2017 Everyone http://www.google.com/policies/privacy False False False 2021-06-16 12:48:22 2017-01-11 2017-11-02
2305532 Google Pay (old app) com.google.android.apps.walletnfcrel Finance 3.8 1059837.0 100,000,000+ 100000000.0 330675089 True 0.0 ... Jun 24, 2011 May 03, 2021 Everyone https://payments.google.com/legaldocument?fami... False False False 2021-06-16 12:52:47 2011-06-24 2021-05-03
2307317 Google Authenticator com.google.android.apps.authenticator2 Tools 3.9 316696.0 50,000,000+ 50000000.0 82020853 True 0.0 ... Mar 21, 2012 May 12, 2020 Everyone http://www.google.com/policies/privacy False False False 2021-06-16 12:54:20 2012-03-21 2020-05-12

224 rows × 26 columns

In [56]:
#Question 16 (No. of Apps within each Content_Rating Category)
playstore.Content_Rating.value_counts().reset_index(name="App_Cnt")
Out[56]:
index App_Cnt
0 Everyone 1122381
1 Teen 110037
2 Mature 17+ 34244
3 Everyone 10+ 20425
4 Adults only 18+ 85
5 Unrated 19
In [57]:
playstore.Content_Rating.value_counts().reset_index()
Out[57]:
index Content_Rating
0 Everyone 1122381
1 Teen 110037
2 Mature 17+ 34244
3 Everyone 10+ 20425
4 Adults only 18+ 85
5 Unrated 19
In [58]:
#Question 12(Most Installed/Downloaded Shooting Game App)
shootingGame=category[category.App_Name.str.contains("kill|shoot|war|fight|crime|action")]
shootingGame
Out[58]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New
2736 Counter FPS shooting strike: New shooting games com.sfgs.counter.shooting.strike.shooting.games Action 4.1 79.0 10,000+ 10000.0 20199 True 0.00 ... sunshinefightinggames@yahoo.com Apr 25, 2020 Apr 25, 2020 Teen https://sites.google.com/view/sunshine-freegam... True False False 2021-06-15 20:22:13 2020-04-25
5086 Blocky Cars - pixel shooter & tank wars com.blockycars.online Action 4.4 428863.0 10,000,000+ 10000000.0 25055030 True 0.00 ... blocky.cars@fullhpltd.com Jul 10, 2015 Apr 22, 2021 Everyone 10+ http://fullhpltd.com/this-privacy-policy/ True True False 2021-06-15 20:24:29 2015-07-10
19145 Z.O.N.A Project X - Post-apocalyptic shooter. com.agaming.zonaprojectx Action 3.0 8167.0 100,000+ 100000.0 234719 False 0.99 ... agamingandroid@gmail.com Aug 22, 2015 Nov 15, 2019 Mature 17+ http://eagaming.org/pages/privacy-policy-googl... False False False 2021-06-15 20:38:17 2015-08-22
21490 Zombie Smasher Squad: Deadly Roadkill Car Surv... com.futurealiti.zombie.smasher.squad.deadly.ro... Action 4.4 7.0 1,000+ 1000.0 1980 True 0.00 ... devaccounts@futurealiti.com Apr 10, 2020 Apr 25, 2020 Teen https://futurealiti.com/privacy-policy/ True True False 2021-06-15 20:40:33 2020-04-10
23512 HumV Dogs Legend : Offline cartoon racing action com.guris.humvdogslegend Action 4.4 45.0 10,000+ 10000.0 12953 True 0.00 ... searoopy@gmail.com Jun 29, 2020 Feb 08, 2021 Everyone https://passman.tistory.com/category/DFFFFF True True False 2021-06-15 20:42:32 2020-06-29
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2285069 Pot shooter com.cybearcode.potshooter Action 0.0 0.0 1,000+ 1000.0 1678 True 0.00 ... contact@cybearcode.com Apr 14, 2021 May 31, 2021 Everyone https://cybearcode.com/privacy-policy True True False 2021-06-16 12:34:43 2021-04-14
2288356 army fight com.virtualinfocom.army.fight Action 4.0 24.0 1,000+ 1000.0 2745 True 0.00 ... arijit79in@gmail.com Feb 15, 2017 Aug 02, 2018 Teen http://ani2pix.com/policy.html True False False 2021-06-16 12:37:39 2017-02-15
2291282 One Gun 2 Stickman rpg shooter gang com.erow.stickgun2 Action 4.4 367.0 100,000+ 100000.0 435844 True 0.00 ... erowhelp@gmail.com Jul 9, 2019 Jun 15, 2021 Everyone 10+ https://erowdev-ffb62.firebaseapp.com/privacy_... True True False 2021-06-16 12:40:11 2019-07-09
2295188 Star Forces: Space shooter com.azurinteractive.StarForces Action 3.3 11110.0 1,000,000+ 1000000.0 1022390 True 0.00 ... zar@azurgames.com Feb 21, 2019 Apr 02, 2019 Teen https://privacy.azurgames.com True True False 2021-06-16 12:43:37 2019-02-21
2311434 Superhero fighter king: Spider Fighting games com.epic_games.superhero.fighter.king Action 4.9 221.0 10,000+ 10000.0 24287 True 0.00 ... epicgamesworld40@gmail.com Sep 5, 2019 Jul 06, 2020 Teen https://epicgamesworld.weebly.com/ True False False 2021-06-16 12:58:00 2019-09-05

355 rows × 25 columns

In [59]:
shootingGame[shootingGame.Maximum_Installs== shootingGame.Maximum_Installs.max()]
Out[59]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Developer_Email Released Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New
438723 West Gunfighter com.cg.cowboy Action 4.2 512701.0 50,000,000+ 50000000.0 87632801 True 0.0 ... contact@candy-mobile.com Apr 19, 2018 Nov 14, 2019 Teen http://www2.candy-mobile.com/policy.htm True True False 2021-06-16 03:40:12 2018-04-19

1 rows × 25 columns

In [60]:
#Question 11(Rating History of Playstore over Years)
playstore['Released_New'] = pd.to_datetime(playstore['Released']).dt.date
playstore['Released_New']
Out[60]:
0          2020-02-26
1          2020-05-21
4          2020-02-21
5          2018-12-24
9          2019-09-22
              ...    
2312933    2014-12-11
2312934    2020-06-15
2312938    2018-05-22
2312940    2018-01-17
2312942    2016-08-01
Name: Released_New, Length: 1287191, dtype: object
In [61]:
playstore['year'] = pd.DatetimeIndex(playstore['Released_New']).year
In [62]:
playstore.head()
Out[62]:
App_Name App_Id Category Rating Rating_Count Installs Minimum_Installs Maximum_Installs Free Price ... Last_Updated Content_Rating Privacy_Policy Ad_Supported In_App_Purchases Editors_Choice Scraped_Time Released_New Last_Updated_New year
0 Gakondo com.ishakwe.gakondo Adventure 0.0 0.0 10+ 10.0 15 True 0.0 ... Feb 26, 2020 Everyone https://beniyizibyose.tk/projects/ False False False 2021-06-15 20:19:35 2020-02-26 2020-02-26 2020
1 Ampere Battery Info com.webserveis.batteryinfo Tools 4.4 64.0 5,000+ 5000.0 7662 True 0.0 ... May 06, 2021 Everyone https://dev4phones.wordpress.com/licencia-de-uso/ True False False 2021-06-15 20:19:35 2020-05-21 2021-05-06 2020
4 GROW.me com.horodyski.grower Tools 0.0 0.0 100+ 100.0 478 True 0.0 ... Nov 12, 2018 Everyone http://www.horodyski.com.pl False False False 2021-06-15 20:19:35 2020-02-21 2018-11-12 2020
5 IMOCCI com.imocci Social 0.0 0.0 50+ 50.0 89 True 0.0 ... Dec 20, 2019 Teen https://www.imocci.com/wp-content/uploads/2018... False True False 2021-06-15 20:19:35 2018-12-24 2019-12-20 2018
9 Neon 3d Iron Tech Keyboard Theme com.ikeyboard.theme.neon_3d.iron.tech Personalization 4.7 820.0 50,000+ 50000.0 62433 True 0.0 ... Oct 07, 2020 Everyone http://bit.ly/EmojiThemePro True False False 2021-06-15 20:19:35 2019-09-22 2020-10-07 2019

5 rows × 27 columns

In [63]:
dm=playstore[['year','Rating']].value_counts()
In [64]:
pg=playstore.groupby(['year']).mean().Rating.reset_index()
pg
Out[64]:
year Rating
0 2010 3.764156
1 2011 3.671509
2 2012 3.568271
3 2013 3.420646
4 2014 3.310734
5 2015 3.056678
6 2016 2.754932
7 2017 2.512189
8 2018 2.282580
9 2019 2.001792
10 2020 1.949656
11 2021 1.434679
In [65]:
fig = px.line(pg, x="year", y="Rating", markers = True)
fig.show()
In [66]:
dm.groupby(level = 0)
Out[66]:
<pandas.core.groupby.generic.SeriesGroupBy object at 0x00000254AC4C7AC0>
In [67]:
dm
Out[67]:
year  Rating
2020  0.0       153622
2019  0.0       136416
2018  0.0        90426
2017  0.0        61962
2021  0.0        47642
                 ...  
2011  1.3            2
2010  1.5            2
2011  1.1            2
2010  1.6            1
      1.3            1
Length: 498, dtype: int64

Question 14¶

In [68]:
#Question 14 (Most Installed App within each category)
playstore.Category.value_counts()
Out[68]:
Education                  127219
Business                   100311
Music & Audio               87008
Lifestyle                   75017
Tools                       67215
Entertainment               63581
Books & Reference           56515
Health & Fitness            51770
Shopping                    48981
Productivity                46960
Travel & Local              46613
Food & Drink                45773
Finance                     44111
Personalization             37819
Communication               30703
News & Magazines            29320
Sports                      29180
Social                      27164
Puzzle                      25069
Casual                      21958
Medical                     20260
Arcade                      19925
Photography                 16827
Maps & Navigation           15821
Educational                 13048
Simulation                  12569
Action                      12385
Auto & Vehicles             10744
Adventure                   10295
House & Home                 8707
Events                       8497
Art & Design                 8007
Video Players & Editors      6883
Beauty                       6179
Trivia                       5885
Role Playing                 5711
Racing                       5383
Board                        5175
Word                         4989
Card                         4858
Strategy                     4117
Weather                      4103
Dating                       3429
Casino                       2810
Parenting                    2381
Libraries & Demo             2371
Music                        2200
Comics                       1345
Name: Category, dtype: int64
In [69]:
# app=playstore[['Category','App_Name']].reset_index().max()
# app
In [70]:
playstore[playstore.Category=='Education'].App_Name.max()
Out[70]:
'🧠 Smart - Brain fitness'
In [71]:
playstore[playstore.Category=='Business'].App_Name.max()
Out[71]:
'🤑Consultar Servicios Públicos Honduras🛠️🇭🇳Free'
In [131]:
ma=playstore[playstore.Category=='Music & Audio'].App_Name.max()
ma
Out[131]:
'\U000e0067\U000e0062\U000e0065\U000e006e\U000e0067\U000e007fRadio England 🏴\U000e0067\U000e0062\U000e0065\U000e006e\U000e0067\U000e007f📻'
In [141]:
playstore[playstore.Category=='Business'].App_Name.Installs.max()
Out[141]:
52          10+
58         100+
94         100+
100         10+
101         10+
           ... 
2312883    100+
2312889      1+
2312914     10+
2312922     50+
2312926    500+
Name: Installs, Length: 100311, dtype: object
In [160]:
cai=playstore[['Category','App_Name','Installs']].value_counts()
cai
Out[160]:
Category          App_Name                                            Installs  
Tools             Flashlight                                          10+           18
Card              Solitaire                                           1,000,000+    16
Health & Fitness  BMI Calculator                                      1,000+        14
Tools             Flashlight                                          100+          14
Puzzle            Sudoku                                              1,000+        13
                                                                                    ..
Music & Audio     رقية الحسد للشيخ ناصر القطامي                       1,000+         1
                  رقية الحسد للشيخ هاني الرفاعي                       1,000+         1
                  رقية الزواج لمن تعطل زواجها أو تأخر نصيبها-بدون نت  10,000+        1
                  رقية الشرعية من الكتاب والسنة                       1,000+         1
Action            "Emoji Run" casual game. 2020 Japan buzzword Emoji  100+           1
Length: 1280394, dtype: int64
In [152]:
cai.groupby(level=[0,1]).sum()
Out[152]:
Category  App_Name                                          
Action    "Emoji Run" casual game. 2020 Japan buzzword Emoji    1
          "Turn-Based" Chaos                                    1
          # storm Area 51                                       1
          'Roid Runner                                          1
          ( ͡° ͜ʖ ͡°) PugWars                                   1
                                                               ..
Word      💚Word Sauce: Free Word Connect Puzzle                 1
          📱 Sopa de Letras Infinitas 📱                          1
          🔥Kitty Scramble: Word Stacks                          1
          😎 Угадай слово по смайликам                           1
          🟢Crocword: Crossword Puzzle Game                      1
Length: 1260765, dtype: int64
In [153]:
cai
Out[153]:
Category          App_Name                                            Installs  
Tools             Flashlight                                          10+           18
Card              Solitaire                                           1,000,000+    16
Health & Fitness  BMI Calculator                                      1,000+        14
Tools             Flashlight                                          100+          14
Puzzle            Sudoku                                              1,000+        13
                                                                                    ..
Music & Audio     رقية الحسد للشيخ ناصر القطامي                       1,000+         1
                  رقية الحسد للشيخ هاني الرفاعي                       1,000+         1
                  رقية الزواج لمن تعطل زواجها أو تأخر نصيبها-بدون نت  10,000+        1
                  رقية الشرعية من الكتاب والسنة                       1,000+         1
Action            "Emoji Run" casual game. 2020 Japan buzzword Emoji  100+           1
Length: 1280394, dtype: int64
In [73]:
playstore[playstore.Category=='Lifestyle '].App_Name.max()
Out[73]:
nan
In [74]:
playstore[playstore.Category=='Tools'].App_Name.max()
Out[74]:
'🧲 Magnetometer Magnetic Sensor Metal Detector'
In [75]:
playstore[playstore.Category=='Entertainment'].App_Name.max()
Out[75]:
'🧴 Desinfectante casero'
In [76]:
playstore[playstore.Category=='Books & Reference '].App_Name.max()
Out[76]:
nan
In [77]:
playstore[playstore.Category=='Health & Fitness'].App_Name.max()
Out[77]:
'🥥107 Way Uses & Health Benefit for Coconut Oil🥥'
In [78]:
playstore[playstore.Category=='Shopping'].App_Name.max()
Out[78]:
'🔥Half Price: Coles, Woolworths'
In [79]:
playstore[playstore.Category=='Productivity '].App_Name.max()
Out[79]:
nan
In [80]:
playstore[playstore.Category=='Travel & Local'].App_Name.max()
Out[80]:
'🛰️ Vex - GPS Tracker'
In [81]:
playstore[playstore.Category=='Food & Drink'].App_Name.max()
Out[81]:
'🥩 Recetas de Vaca Gratis 🥩'
In [82]:
playstore[playstore.Category=='Finance '].App_Name.max()
Out[82]:
nan
In [83]:
playstore[playstore.Category=='Personalization'].App_Name.max()
Out[83]:
'🦾Best Superhero wallpaper and Lock screen HD'
In [84]:
playstore[playstore.Category=='Communication '].App_Name.max()
Out[84]:
nan
In [85]:
playstore[playstore.Category=='News & Magazines'].App_Name.max()
Out[85]:
'📰Новости АВТО: тест-драйвы, обзоры, новинки'
In [86]:
playstore[playstore.Category=='Sports'].App_Name.max()
Out[86]:
'🤸 Aerobics, routines of aerobic exercises 🧘\u200d♀️'
In [87]:
playstore[playstore.Category=='Social'].App_Name.max()
Out[87]:
'🙏Recibe la Paz de lo Alto😀Mi Paz os Doy👍Ten FE'
In [88]:
playstore[playstore.Category=='Puzzle'].App_Name.max()
Out[88]:
'🥇 Cube Puzzle 3D 🥇'
In [89]:
playstore[playstore.Category=='Casual'].App_Name.max()
Out[89]:
'🧜\u200d♀️👸Mermaid Makeup Salon'
In [90]:
playstore[playstore.Category=='Medical'].App_Name.max()
Out[90]:
'🐕 Home Remedies For Dogs 🐕'
In [91]:
playstore[playstore.Category=='Arcade'].App_Name.max()
Out[91]:
'🧱 Breaking Bad Bricks 😎'
In [92]:
playstore[playstore.Category=='Photography'].App_Name.max()
Out[92]:
'🦁 Lion Wallpaper : Wild King Backgrounds'
In [93]:
playstore[playstore.Category=='Maps & Navigation'].App_Name.max()
Out[93]:
'🚦Bangalore Traffic Fine/Challan Checker'
In [94]:
playstore[playstore.Category=='Educational'].App_Name.max()
Out[94]:
"🧹🧽Mom's Sweet Helper - House Spring Cleaning"
In [95]:
playstore[playstore.Category=='Simulation'].App_Name.max()
Out[95]:
'🧜\u200d♀️Mermaid Princess Makeup & Dress Up Girls Game'
In [96]:
playstore[playstore.Category=='Action'].App_Name.max()
Out[96]:
'🧟Zombie Ops 3D shooter - sniper undead revenants'
In [97]:
playstore[playstore.Category=='Auto & Vehicles'].App_Name.max()
Out[97]:
'🛵 Scooter Modification App'
In [98]:
playstore[playstore.Category=='Adventure'].App_Name.max()
Out[98]:
'🧨Heroes of Match 3'
In [99]:
playstore[playstore.Category=='House & Home'].App_Name.max()
Out[99]:
'🕯️Candle light: MEDITATION🤔, RELAX😌 and SLEEP😴'
In [100]:
playstore[playstore.Category=='Events'].App_Name.max()
Out[100]:
'🎵 Aishwa Nahla - Marhaban Yaa Ramadhan'
In [101]:
playstore[playstore.Category=='Art & Design'].App_Name.max()
Out[101]:
'🦄 Rainbow Unicorn Glitter Wallpaper 4K [UHD]'
In [102]:
playstore[playstore.Category=='Video Players & Editors'].App_Name.max()
Out[102]:
'📷 Video To  Photo Converter'
In [103]:
playstore[playstore.Category=='Beauty'].App_Name.max()
Out[103]:
'📻 Rádio 105 FM (Jundiaí - SP)'
In [104]:
playstore[playstore.Category=='Trivia'].App_Name.max()
Out[104]:
'🛸 UFO Quiz 2020 🛸'
In [105]:
playstore[playstore.Category=='Role Playing'].App_Name.max()
Out[105]:
'🧚 Fairy Princess Makeup Dress Up Girls Game'
In [106]:
playstore[playstore.Category=='Racing'].App_Name.max()
Out[106]:
'🚗🏁UAZ 4x4: Dirt Offroad Rally Racing Simulator'
In [107]:
playstore[playstore.Category=='Board'].App_Name.max()
Out[107]:
'🐍 Snakes and Ladders Board Games 🎲'
In [108]:
playstore[playstore.Category=='Word'].App_Name.max()
Out[108]:
'🟢Crocword: Crossword Puzzle Game'
In [109]:
playstore[playstore.Category=='Card'].App_Name.max()
Out[109]:
'🎴 Hanafuda Koi-Koi Ramen (Free)'
In [110]:
playstore[playstore.Category=='Strategy'].App_Name.max()
Out[110]:
'🔫 Toy Commander: Army Men Battles'
In [111]:
playstore[playstore.Category=='Weather'].App_Name.max()
Out[111]:
'🌕 Leuksna - Moon calendar & moon phases'
In [112]:
playstore[playstore.Category=='Dating'].App_Name.max()
Out[112]:
'😍 La La Chat - Meet New Friends and Free Dating'
In [113]:
playstore[playstore.Category=='Casino'].App_Name.max()
Out[113]:
'💰 Spinner Slots 🎰 Fidget Fun Casino 💎'
In [114]:
playstore[playstore.Category=='Parenting '].App_Name.max()
Out[114]:
nan
In [115]:
playstore[playstore.Category=='Libraries & Demo'].App_Name.max()
Out[115]:
'👷\u200d DUARIB 🕹️🛠️'
In [116]:
playstore[playstore.Category=='Music'].App_Name.max()
Out[116]:
'😱 Undertale Deltarune songs - Piano tiles offline'
In [117]:
playstore[playstore.Category=='Comics'].App_Name.max()
Out[117]:
'할리퀸만화 – 미스터블루가 엄선한 할리퀸웹툰, 무료만화'

Question 10¶

In [118]:
#Question 10 (Smallest & Largest App size on the store)
playstore.columns
Out[118]:
Index(['App_Name', 'App_Id', 'Category', 'Rating', 'Rating_Count', 'Installs',
       'Minimum_Installs', 'Maximum_Installs', 'Free', 'Price', 'Currency',
       'Size', 'Minimum_Android', 'Developer_Id', 'Developer_Website',
       'Developer_Email', 'Released', 'Last_Updated', 'Content_Rating',
       'Privacy_Policy', 'Ad_Supported', 'In_App_Purchases', 'Editors_Choice',
       'Scraped_Time', 'Released_New', 'Last_Updated_New', 'year'],
      dtype='object')
In [119]:
playstore.Size.max()
Out[119]:
'Varies with device'
In [120]:
playstore.Size.min()
Out[120]:
'1,000k'
In [121]:
playstore.Size.unique()
Out[121]:
array(['10M', '2.9M', '6.2M', ..., '314M', '512M', '405M'], dtype=object)
In [161]:
# sel_chng_type = list(set(['Size']))
# sel_chng_type
br=type(playstore.Size[0])
br
Out[161]:
str
In [180]:
size=pd.Series([playstore.Size])
size
Out[180]:
0    0           10M
1          2.9M
4          6.2...
dtype: object
In [ ]: